Scenario 2 - Lookups

"Sales Data.xlsx" contains 2 sheets, "Sales" and "Product Codes"
The "Sales" sheet contains a "Product ID" column. The "Product Codes" sheet contains a mapping table to map the codes to product names.

We can add both sheets to EasyMorph
Use the "Lookup" action configured to map the values in. 

We can reorder the columns to put the product name by the code by simply dragging the column. 

Looking at the data we can see that some codes haven't been mapped as code 1 is missing (it should be "Desktop"). There might be more though so we should use the table meta data to check.

We could fix the issue adding the missing value in EasyMorph but it makes more sense to add the missing product to the spreadsheet and rerun our workflow to see the problem is resolved. 

Also worth noting that there is a duplicate (product code 4) in the mapping table. This doesn't cause any issues in the Lookup action as they are identical but we'll see how duplicates can cause problems in other modes in the next example.